An Architecture for Managing Database Evolution
نویسندگان
چکیده
This paper presents an architecture for managing database evolution when all the components of the database (conceptual schema, logical schema and extension) are available. The strategy of evolution in which our architecture is based is that of ‘forward database maintenance’, that is, changes are applied to the conceptual schema and propagated automatically down to the logical schema and to the extension. In order to put into practice this strategy, each component of a database is seen under this architecture as the information base of an information system. Furthermore, a translation information system is considered in order to manage the translation of conceptual elements into logical schema elements. A current Oracle implementation of this architecture is also presented.
منابع مشابه
Architecture for Dynamic Schema Evolution in Heterogeneous Database Environments: A Prototype System and Its Evaluation
Dynamic schema evolution is the process of evolving a database schema by incorporating changes in a timely manner, without loss of existing data, and without significantly affecting the day-to-day operations of the database. Systems that manage schema evolution are described in the literature, but address schema evolution single, stand-alone, object-oriented databases. Organizations typically u...
متن کاملDynamically Managing Schema Changes in a HDE – Pitfalls and Possibilities
The schema of a database changes and evolves extensively even in an operational database. Managing schema evolution is an important problem in databases and the large body of literature reflects the extensive work on this topic. Managing schema evolution in a heterogeneous data environment (HDE) has however not been addressed at all. Further more automating schema evolution has received little ...
متن کاملAn Architecture for Managing Schema Evolution in a Federated Spatial Database System
A Federated Spatial Database System (FSDBS) is the integration of multiple spatial data sources and the realisation of effective spatial data sharing. FSDBS environments are becoming increasingly popular as more and more spatial and non-spatial datasets are integrated, especially those across a number of independent organisations. However, in a FSDBS environment, database schemas are subject to...
متن کاملApplication of Information Technology: Dynamic Tables: An Architecture for Managing Evolving, Heterogeneous Biomedical Data in Relational Database Management Systems
Data sparsity and schema evolution issues affecting clinical informatics and bioinformatics communities have led to the adoption of vertical or object-attribute-value-based database schemas to overcome limitations posed when using conventional relational database technology. This paper explores these issues and discusses why biomedical data are difficult to model using conventional relational t...
متن کاملDynamic Tables: An Architecture for Managing Evolving, Heterogeneous Data in Relational Database Management Systems
Data sparsity and schema evolution issues affecting bioinformatics and medical informatics communities have forced the adoption of vertical or object-attribute-value based database schemas to overcome limitations posed when using conventional relational database technology. Through our collaboration with the Yale Center for Medial Informatics (YCMI), we explore the reasons for this and show why...
متن کامل